oracle10g 添加监听数手动配置方式
oracle10g 添加监听数手动配置方式
数据库 oracle
找到oracle安装目录C:\Oracle\product\10.1.0\Client_1\NETWORK\ADMIN\tnsnames.ora文件，像如下便是你要添加的连接远程数据库监听
DEMODB2_192.168.1.214 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.214)(PORT = 1521))
)
(CONNECT_DATA =
(SID = demodb2)
(SERVER = DEDICATED)
)
)
